create  table jms_dm.dm_repair_access_sum_dt 
(
scan_network_code        varchar(100) COMMENT '维修点编码' ,
scan_network_name        varchar(100) COMMENT '维修点名称' ,
 total_in_num             bigint COMMENT '入库数量' ,
 damage_num  bigint COMMENT '未仲裁上报数量' ,
 total_out_num   bigint COMMENT '出库数量' ,
 center_num   bigint COMMENT '中心入库数量' ,
 total_off_num    bigint COMMENT '报废数量' ,
date_time timestamp COMMENT '' )
ENGINE=OLAP
DUPLICATE KEY(填写key)
comment 'insert overwrite table jms_dm.dm_repair_access_sum_dt partition (dt)'
PARTITION BY RANGE (date_time) ( 
   START ("2023-09-11") END ("2023-11-10") EVERY (INTERVAL 1 day))
DISTRIBUTED BY HASH(site_code) BUCKETS 4
PROPERTIES (
"replication_num" = "3",
"dynamic_partition.enable" = "true",
"dynamic_partition.time_unit" = "DAY",
"dynamic_partition.time_zone" = "Asia/Shanghai",
"dynamic_partition.start" = "-365",
"dynamic_partition.end" = "3",
"dynamic_partition.prefix" = "p",
"dynamic_partition.buckets" = "4",
"in_memory" = "false",
"storage_format" = "V2"
);